{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\hilar\Box\lights_2022\replication package\code\read_lights_drought.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}11 Dec 2025, 15:44:23
{txt}
{com}. timer on 1
{txt}
{com}. clear
{txt}
{com}. 
. cd "../data/grid_ascii"
{res}C:\Users\hilar\Box\lights_2022\replication package\data\grid_ascii
{txt}
{com}. 
. 
. forvalues yr = 2000(1)2011 {c -(} 
{txt}  2{com}. 
. *droughts
. ras2dta, file(drought_`yr') genxcoord(x) genycoord(y) dropmiss 
{txt}  3{com}. rename drought_`yr' drought
{txt}  4{com}. tempfile drought_`yr'
{txt}  5{com}. save `drought_`yr'', replace
{txt}  6{com}. clear
{txt}  7{com}. 
. 
. *ihs lights
. ras2dta, file(lights_05deg_ihs_`yr') genxcoord(x) genycoord(y) 
{txt}  8{com}. rename lights_05deg_ihs_`yr' ihslights
{txt}  9{com}. tempfile lights_05deg_ihs_`yr'
{txt} 10{com}. save `lights_05deg_ihs_`yr'', replace
{txt} 11{com}. clear
{txt} 12{com}. 
. *levels of lights
. ras2dta, file(lights_05deg_`yr') genxcoord(x) genycoord(y) 
{txt} 13{com}. rename lights_05deg_`yr' lights
{txt} 14{com}. 
. merge 1:1 x y using `drought_`yr'', keep(match)
{txt} 15{com}. drop _merge
{txt} 16{com}. merge 1:1 x y using `lights_05deg_ihs_`yr'', keep(match)
{txt} 17{com}. drop _merge
{txt} 18{com}. 
. gen int year=`yr'
{txt} 19{com}. 
. tempfile drought_lights_`yr'
{txt} 20{com}. save `drought_lights_`yr'', replace
{txt} 21{com}. clear
{txt} 22{com}. {c )-}

{txt}{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2000.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000001.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000001.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2000.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000002.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000002.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2000.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000003.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000003.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2001.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000004.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000004.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2001.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000005.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000005.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2001.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000006.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000006.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2002.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000007.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000007.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2002.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000008.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000008.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2002.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000009.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000009.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2003.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000a.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000a.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2003.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000b.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000b.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2003.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000c.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000c.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2004.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000d.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000d.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2004.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000e.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000e.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2004.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000f.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000f.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2005.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000g.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000g.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2005.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000h.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000h.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2005.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000i.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000i.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2006.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000j.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000j.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2006.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000k.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000k.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2006.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000l.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000l.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2007.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000m.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000m.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2007.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000n.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000n.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2007.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000o.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000o.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2008.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000p.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000p.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2008.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000q.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000q.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2008.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000r.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000r.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2009.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000s.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000s.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2009.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000t.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000t.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2009.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000u.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000u.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2010.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000v.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000v.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2010.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000w.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000w.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2010.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000x.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_00000x.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
drought_2011.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000010.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000010.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_ihs_2011.dta{rm}
saved
{p_end}
{res}{txt}{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000011.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000011.tmp{rm}
saved
as .dta format
{p_end}

{hline 30}
No of {res}columns{txt}: {col 20}{res}      7,200
{txt}No of {res}rows{txt}: {col 20}{res}      2,700
{txt}number of {res}cells{txt}: {col 20}{res}   19440000
{txt}{p 0 4 2}
file {bf}
lights_05deg_2011.dta{rm}
saved
{p_end}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       4,881,146{txt}  (_merge==3)
{col 5}{hline 41}
{p 0 4 2}
(file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000012.tmp{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:\Users\hilar\AppData\Local\Temp\ST_3190_000012.tmp{rm}
saved
as .dta format
{p_end}

{com}. 
. 
. use `drought_lights_2000'
{txt}
{com}. forvalues yr = 2001(1)2011 {c -(} 
{txt}  2{com}. append using `drought_lights_`yr''
{txt}  3{com}. {c )-}
{txt}
{com}. 
. sort x y year
{txt}
{com}. 
. cd ..
{res}C:\Users\hilar\Box\lights_2022\replication package\data
{txt}
{com}. 
. save grid_lights_drought, replace
{txt}{p 0 4 2}
(file {bf}
grid_lights_drought.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
grid_lights_drought.dta{rm}
saved
{p_end}

{com}. 
. 
. timer list
{txt}
{com}. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\hilar\Box\lights_2022\replication package\code\read_lights_drought.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}11 Dec 2025, 16:49:30
{txt}{.-}
{smcl}
{txt}{sf}{ul off}